CustomerRewardRebateLineItem

Entity Definition

Logical Name : CustomerRewardRebateLineItem
Physical Name : TR_CT_RWD_RBT_LN_ITM

A type of CustomerRewardLineItem used to record the earning, redemption and adjustment of REBATES. CUSTOMER REBATES are rewards that a customer earns and may claim after a purchase is completed. Customer rebates may be INSTANT REBATES or DEFERRABLE REBATES. Instant rebates are earned and redeemed within the same transaction. The earning part of an instant rebate is represented by an earn activity code in the parent CustomerRewardLineItem. Instant rebates are subtracted from a purchase price after it is recorded. The rebate value is represented by a redemption/settlement CustomerRewardLineItem. An INSTANT REBATE always has two CustomerRewardLineItem and CustomerRewardRebateLineItem instances for any rebate captured as part of a retail transaction. The first covers the earning of the rebate (which is a rebate claim). The second is a rebate redemption/settlement which is the payment of the rebate value to the customer. To the customer instant rebates are nearly indistinguishable from a discount. Within the ARTS ODM instant rebates and discounts are very different concepts (see the ODM Narrative Section: Understanding Rebates for a detailed explanation). Customer Rebates may be DEFERRABLE rewards. This means that a rebate is earned in a transaction, added to a rebate payable balance and paid to the customer at a future time through a separate transaction. Deferrable rebates will be recorded as two CustomerRewardLineItem - CustomerRewardRebateLineItem entity type instances. The first captures the earning of a rebate. The second captures the posting of the liability established for the future return of the rebate value to the customer.

Data Definition

Attribute	Description	Physical Name	Domain	Data Type	Foreign Key Table
RebateID (PK)	Token ID for a CustomerRewardRebate	ID_RBT	Identity	integer
TransactionID (FK)(PK)	A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members.	ID_TRN	IdentityUUID	char(32)	CustomerRewardLineItem(TR_CT_RWD_LN_ITM)
RetailTransactionLineItemSequenceNumber (FK)(PK)	The sequence number of line item within the context of this RetailTransaction.	IC_LN_ITM	LineNumber	smallint	CustomerRewardLineItem(TR_CT_RWD_LN_ITM)
SalesReceiptRequiredFlag	Boolean indicator that if YES means that a rebate beneficiary must subit the sales receipt on which the item being claimed for a rebate was sold. If NO the rebate claimant does NOT have to submit the original sales receipt.	FL_SLS_RCT_RQ	Flag	integer
RebateCustomerSettlementModeCode	Defines that way customers receive rebates. Used to distinguish between mail in rebates, instant rebates and deferred rebate settlements. Valid Values are: MAILIN (deferred payout ) INSTANT (immediate payout within retail transaction) DEFERRED_SETTLEMENT (aka "dividend") Note does not establish the currency used for rebates (i.e. cash, points, premium gift items, stored value items, etc.)	CD_RBT_CT_STLM_MOD	Code	varchar(20)
RebateCustomerSettlementPaymentTypeCode	Designates the way a rebate value is transferred to a beneficiaryr. Enumerated value lists are defined by the retailer. Examples include: CASH SENDCHECK DBCRCARD_CREDIT DISCOUNT PREMIUM_ITEM LOYALTY_POINTS STORED_VALUE STORE_CREDIT For scenarios where a rebate beneficiary is the retailer itself examples include: BILL_BACK (in effect a receivable) PURCHASE_DISCOUNT (take value off next purchase from the sponsor) There are other more esoteric forms of payment like advertising subsidies, jointly sponsored promotional events, etc.	CD_RBT_CT_PYM_CNY_TYP	Code	varchar(20)
EffectiveDate	The date a RebateProgram begins.	DT_EF	EffectiveDate	date
ExpirationDate	The date a RebateProgram ends	DT_EP	ExpirationDate	date
StatusCode	The current state of a RebateProgram. Sample values are: ACTIVE INACTIVE	CD_STS_RBT_PRGM	Code2Status	char(2)
CustomerRebateAccountProgramID (FK)	A token ID for a CustomerRebateAccountProgram	ID_CT_RBT_ACNT_PRGM	Identity	integer	CustomerRebateAccountProgram(CO_CT_RBT_ACNT_PRGM)

Relationships

Parent Entity	Verb Phrase	Child Entity
CustomerRebateAccountProgram	earns or redeems	CustomerRewardRebateLineItem
CustomerRewardLineItem	is a	CustomerRewardRebateLineItem

Logical Views containing CustomerRewardRebateLineItem

Logical View
Logical 01400 - Item Rewards Derivation - Transaction Level
Logical 02300 - Retail Transaction - Macro View